Tabela TimeStampRule

Definicja tabeli TimeStampRule

Name

TimeStampRule

Code

TimeStampRule

Comment

Reguly punktów czasowych


Lista kolumn tabeli TimeStampRule

Name

Code

TimeStampRuleID

TimeStampRuleID

StartTimeStampID

StartTimeStampID

StopTimeStampID

StopTimeStampID

RuleServiceID

RuleServiceID

RuleServiceTypeID

RuleServiceTypeID

RuleAttributeID

RuleAttributeID

CostServiceID

CostServiceID

TimeStampMultiplicityKindID

TimeStampMultiplicityKindID

UnitsCount

UnitsCount

Active

Active

InsertingPerson

InsertingPerson

InsertDT

InsertDT

LastModifiedPerson

LastModifiedPerson

SysFctID

SysFctID

LastModifiedDT

LastModifiedDT


Kolumna TimeStampRuleID tabeli TimeStampRule

Definicja kolumny TimeStampRuleID tabeli TimeStampRule

Name

TimeStampRuleID

Code

TimeStampRuleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartTimeStampID tabeli TimeStampRule

Definicja kolumny StartTimeStampID tabeli TimeStampRule

Name

StartTimeStampID

Code

StartTimeStampID

Data Type

NUMBER(10)

Mandatory

No

Comment

Poczatkowy punkt czasowy


Kolumna StopTimeStampID tabeli TimeStampRule

Definicja kolumny StopTimeStampID tabeli TimeStampRule

Name

StopTimeStampID

Code

StopTimeStampID

Data Type

NUMBER(10)

Mandatory

No

Comment

Koncowy punkt czasowy


Kolumna RuleServiceID tabeli TimeStampRule

Definicja kolumny RuleServiceID tabeli TimeStampRule

Name

RuleServiceID

Code

RuleServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kryterium reguly: usluga


Kolumna RuleServiceTypeID tabeli TimeStampRule

Definicja kolumny RuleServiceTypeID tabeli TimeStampRule

Name

RuleServiceTypeID

Code

RuleServiceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kryterium reguly: typ uslugi


Kolumna RuleAttributeID tabeli TimeStampRule

Definicja kolumny RuleAttributeID tabeli TimeStampRule

Name

RuleAttributeID

Code

RuleAttributeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kryterium reguly: atrybut formularza


Kolumna CostServiceID tabeli TimeStampRule

Definicja kolumny CostServiceID tabeli TimeStampRule

Name

CostServiceID

Code

CostServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

Usluga kodowana w ramach reguly


Kolumna TimeStampMultiplicityKindID tabeli TimeStampRule

Definicja kolumny TimeStampMultiplicityKindID tabeli TimeStampRule

Name

TimeStampMultiplicityKindID

Code

TimeStampMultiplicityKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Sposób obliczania krotnosci


Kolumna UnitsCount tabeli TimeStampRule

Definicja kolumny UnitsCount tabeli TimeStampRule

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Kodowana krotnosc (domyslnie 1)


Kolumna Active tabeli TimeStampRule

Definicja kolumny Active tabeli TimeStampRule

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertingPerson tabeli TimeStampRule

Definicja kolumny InsertingPerson tabeli TimeStampRule

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Osoba dodajaca


Kolumna InsertDT tabeli TimeStampRule

Definicja kolumny InsertDT tabeli TimeStampRule

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedPerson tabeli TimeStampRule

Definicja kolumny LastModifiedPerson tabeli TimeStampRule

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Ostatni modyfikujacy


Kolumna SysFctID tabeli TimeStampRule

Definicja kolumny SysFctID tabeli TimeStampRule

Name

SysFctID

Code

SysFctID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli TimeStampRule

Definicja kolumny LastModifiedDT tabeli TimeStampRule

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

Yes

Comment

Data ostatniej modyfikacji


Lista kluczy tabeli TimeStampRule

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TimeStampRule

Definicja klucza Identifier_1 tabeli TimeStampRule

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment